{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Welcome","Hidden","Investment","Inventory","Electronics","Clothing","Medical","Furniture","Media"],"not_rendered":{"charts":1,"images":8,"macros":1,"external_links":1,"defined_names":438,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,1,3,13],[0,1,1,13]]}
[null,"WELCOME"]
[]
[null,"Amazon Inventory and Investment Analysis System"]

{"sheet":"Hidden","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["UserName","Password","Name","Role",null,null,"Department","Products"]
["milena1",111,"Milena","Product",null,null,"Electronics","TVs"]
["alaiya2",222,"Alaiya","Product",null,null,"Clothing","Laptops"]
["vasil3",333,"Vasil","Product",null,null,"Medical","Tablets"]
["todd4",444,"Todd","Product",null,null,"Furniture","Shirts"]
["sabriyya5",555,"Sabriyya","Supply",null,null,"Movies/shows","Pants"]
["brothwood6",666,"Brothwood","Supply",null,null,null,"Socks"]
["mack7",777,"Mack","Supply",null,null,null,"Mucinex"]
[null,null,null,null,null,null,null,"Eye Drops"]
[null,null,null,null,null,null,null,"Ibuprofen"]
[null,null,null,null,null,null,null,"Couchs"]
[null,null,null,null,null,null,null,"Tables"]
[null,null,null,null,null,null,null,"Chairs"]
[null,null,null,null,null,null,null,"Movies"]
[null,null,null,null,null,null,null,"Shows"]
[null,null,null,null,null,null,null,"Sports"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Row Labels","Sum of Investment"]
[null,null,"Clothing",15000]
[null,null,"Electronics",0]
[null,null,"Furniture",0]
[null,null,"Medical",15000]
[null,null,"Media2",0]
[null,null,"Grand Total",30000]

{"sheet":"Investment","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5]]}
["DEPARTMENT INVESTMENT AND ALLOCATION MODEL"]
["Finds the best allocation of what each department needs and where to max return and min loss "]
[]
[]
["Options","Selected","Allocation","Investment","Return Rate","Risk Rate"]
["Electronics",0,5000,{"$f":"Selected*Allocation","v":0},0.76336134901735619,0.5734737392163366,null,null,"User Inputs:"]
["Clothing",1,15000,{"$f":"Selected*Allocation","v":15000},0.80467359810974259,0.32691442123338293,null,null,"Min to Select"]
["Medical",1,15000,{"$f":"Selected*Allocation","v":15000},0.34249197009020893,0.12084909084595558,null,null,"Min Allocation"]
["Furniture",0,5000,{"$f":"Selected*Allocation","v":0},0.3853864346404724,0.3529662340504226,null,null,"Max Allocation"]
["Media",0,5000,{"$f":"Selected*Allocation","v":0},0.54467695586716058,0.3961787304997621,null,null,"Available Funds"]
[null,null,null,null,null,null,null,null,"Return Rates &"]
[null,"Total Selected","Min Allocation","Total Invested",null,"Expected Returns",null,null,"Risk Rates"]
[null,{"$f":"SUM(Selected)","v":2},5000,{"$f":"SUM(Investment)","v":30000},null,{"$f":"SUMPRODUCT(Return_Rate,Investment)","v":17207.483522999271}]
[null,"Min to Select","Max Allocation","Available Funds",null,"Expected Risk"]
[null,1,15000,30000,null,{"$f":"SUMPRODUCT(Risk_Rate,Investment)","v":6716.4526811900778}]
[null,null,null,null,null,"Expected Profit"]
[null,null,null,null,null,{"$f":"Expected_Returns-Expected_Risk","v":10491.030841809194}]
[]
[null,"Objective","Max Exp Returns","Min Exp Risk"]
[null,"Expected Profit",6469.52,4401.6000000000004]

{"sheet":"Inventory","index":3,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,0,0,13],[2,0,2,1],[2,3,2,4],[2,6,2,7],[2,9,2,10],[2,12,2,13],[1,0,1,13]]}
["Summary Department Inventory - Ordering Model "]
["Uses input from based off of the current inventory model helps us know where is best to invest money. We can use that knowledge to minimize loss or maximize profit "]
["Electronics",null,null,"Clothing",null,null,"Medical",null,null,"Furniture ",null,null,"Media ",null,null,"Total Costs","Available Funds","Total Profit"]
["Total Profit",{"$f":"Electronics!J10-Electronics!H13","v":205.38162243669842},null,"Total Profit",{"$f":"Clothing!J10-Clothing!H13","v":110.35162243669839},null,"Total Profit",{"$f":"Medical!J10-Medical!H13","v":110.35162243669839},null,"Total Profit",{"$f":"Furniture!J10-Furniture!H13","v":110.35162243669839},null,"Total Profit",{"$f":"Media!J10-Media!H13","v":110.35162243669839},null,{"$f":"SUM(B5,E5,H5,K5,N5)","v":2378.42},{"$f":"AvailFund","v":30000},{"$f":"SUM(B4,E4,H4,K4,N4)","v":646.78811218349188}]
["Total Costs",{"$f":"Electronics!H13","v":399.65999999999997},null,"Total Costs",{"$f":"Clothing!H13","v":494.69},null,"Total Costs",{"$f":"Medical!H13","v":494.69},null,"Total Costs",{"$f":"Furniture!H13","v":494.69},null,"Total Costs",{"$f":"Media!H13","v":494.69}]
["Available Funds",{"$f":"Electronics!I13","v":500},null,"Available Funds",500,null,"Available Funds",{"$f":"Medical!I13","v":500},null,"Available Funds",{"$f":"Furniture!I13","v":500},null,"Available Funds",{"$f":"Media!I13","v":500}]
[]
["Total Order Quantity",null,null,"Total Order Quantity",null,null,"Total Order Quantity",null,null,"Total Order Quantity",null,null,"Total Order Quantity"]
[" Min ",{"$f":"Electronics!I17","v":70},null," Min ",{"$f":"Clothing!I17","v":71},null," Min ",{"$f":"Medical!I17","v":71},null," Min ",{"$f":"Furniture!I17","v":71},null," Min ",{"$f":"Media!I17","v":71}]
["Max",{"$f":"Electronics!J17","v":29},null,"Max",{"$f":"Clothing!J17","v":29},null,"Max",{"$f":"Medical!J17","v":29},null,"Max",{"$f":"Furniture!J17","v":29},null,"Max",{"$f":"Media!J17","v":29}]

{"sheet":"Electronics","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,9]]}
["Electronics Ordering Model "]
["Product","Current Inventory","Expected Demand","Order Quantity","Updated Inventory","Actual Sales","Lost Sales","Order Cost","Lost Sales Cost","Sales Price"]
["Television",5,22,20,{"$f":"Current_Inventory+Order_Quantity","v":25},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":22},{"$f":"Expected_Demand-Actual_Sales","v":0},7.31,2.9233212050722779,13.135279504855134]
["Laptops",9,17,38,{"$f":"Current_Inventory+Order_Quantity","v":47},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":17},{"$f":"Expected_Demand-Actual_Sales","v":0},6.67,3.3633533400544113,12.765708637454392]
["Tablets",13,10,0,{"$f":"Current_Inventory+Order_Quantity","v":13},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":10},{"$f":"Expected_Demand-Actual_Sales","v":0},5.84,2.5269157815241625,9.9048426493160715]
[]
[]
[]
[null,"User Input:",null,null,null,null,null,"Total Order","Total Lost Sales","Total Revenue"]
[null,"Current Inventory",null,null,null,null,null,{"$f":"SUMPRODUCT(H3:H5,D3:D5)","v":399.65999999999997},{"$f":"SUMPRODUCT(I3:I5,G3:G5)","v":0},{"$f":"SUMPRODUCT(J3:J5,F3:F5)","v":605.04162243669839}]
[null,"Expected Demand"]
[null,"Lost Sales Cost",null,null,null,null,null,"Total Costs","Available Funds","Total Profit"]
[null,"Order Cost",null,null,null,null,null,{"$f":"SUM(H10:I10)","v":399.65999999999997},500,{"$f":"Total_Revenue-Total_Costs","v":205.38162243669842}]
[null,"Sales Price"]
[]
[null,null,null,null,null,null,null,"Objective","Min Total Lost Sales Cost","Max Profit"]
[null,null,null,null,null,null,null,"Total Order Quantity",70,29]

{"sheet":"Clothing","index":5,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,9]]}
["Clothing Ordering Model "]
["Product","Current Inventory","Expected Demand","Order Quantity","Updated Inventory","Actual Sales","Lost Sales","Order Cost","Lost Sales Cost","Sales Price"]
["Shirts",5,22,33,{"$f":"Current_Inventory+Order_Quantity","v":38},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":22},{"$f":"Expected_Demand-Actual_Sales","v":0},7.31,2.9233212050722779,13.135279504855134]
["Pants",9,17,38,{"$f":"Current_Inventory+Order_Quantity","v":47},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":17},{"$f":"Expected_Demand-Actual_Sales","v":0},6.67,3.3633533400544113,12.765708637454392]
["Socks",13,10,0,{"$f":"Current_Inventory+Order_Quantity","v":13},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":10},{"$f":"Expected_Demand-Actual_Sales","v":0},5.84,2.5269157815241625,9.9048426493160715]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Order","Total Lost Sales","Total Revenue"]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(H3:H5,D3:D5)","v":494.69},{"$f":"SUMPRODUCT(I3:I5,G3:G5)","v":0},{"$f":"SUMPRODUCT(J3:J5,F3:F5)","v":605.04162243669839}]
[]
[null,null,null,null,null,null,null,"Total Costs","Available Funds","Total Profit"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:I10)","v":494.69},500,{"$f":"Total_Revenue-Total_Costs","v":110.35162243669839}]
[]
[]
[null,null,null,null,null,null,null,"Objective","Min Total Lost Sales Cost","Max Profit"]
[null,null,null,null,null,null,null,"Total Order Quantity",71,29]

{"sheet":"Medical","index":6,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,9]]}
["Medical Ordering Model "]
["Product","Current Inventory","Expected Demand","Order Quantity","Updated Inventory","Actual Sales","Lost Sales","Order Cost","Lost Sales Cost","Sales Price"]
["Mucinex",5,22,33,{"$f":"Current_Inventory+Order_Quantity","v":38},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":22},{"$f":"Expected_Demand-Actual_Sales","v":0},7.31,2.9233212050722779,13.135279504855134]
["Eye Drops",9,17,38,{"$f":"Current_Inventory+Order_Quantity","v":47},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":17},{"$f":"Expected_Demand-Actual_Sales","v":0},6.67,3.3633533400544113,12.765708637454392]
["Ibuprofen",13,10,0,{"$f":"Current_Inventory+Order_Quantity","v":13},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":10},{"$f":"Expected_Demand-Actual_Sales","v":0},5.84,2.5269157815241625,9.9048426493160715]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Order","Total Lost Sales","Total Revenue"]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(H3:H5,D3:D5)","v":494.69},{"$f":"SUMPRODUCT(I3:I5,G3:G5)","v":0},{"$f":"SUMPRODUCT(J3:J5,F3:F5)","v":605.04162243669839}]
[]
[null,null,null,null,null,null,null,"Total Costs","Available Funds","Total Profit"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:I10)","v":494.69},500,{"$f":"Total_Revenue-Total_Costs","v":110.35162243669839}]
[]
[]
[null,null,null,null,null,null,null,"Objective","Min Total Lost Sales Cost","Max Profit"]
[null,null,null,null,null,null,null,"Total Order Quantity",71,29]

{"sheet":"Furniture","index":7,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,9]]}
["Furniture Ordering Model "]
["Product","Current Inventory","Expected Demand","Order Quantity","Updated Inventory","Actual Sales","Lost Sales","Order Cost","Lost Sales Cost","Sales Price"]
["Couches",5,22,33,{"$f":"Current_Inventory+Order_Quantity","v":38},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":22},{"$f":"Expected_Demand-Actual_Sales","v":0},7.31,2.9233212050722779,13.135279504855134]
["Tables",9,17,38,{"$f":"Current_Inventory+Order_Quantity","v":47},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":17},{"$f":"Expected_Demand-Actual_Sales","v":0},6.67,3.3633533400544113,12.765708637454392]
["Chairs",13,10,0,{"$f":"Current_Inventory+Order_Quantity","v":13},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":10},{"$f":"Expected_Demand-Actual_Sales","v":0},5.84,2.5269157815241625,9.9048426493160715]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Order","Total Lost Sales","Total Revenue"]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(H3:H5,D3:D5)","v":494.69},{"$f":"SUMPRODUCT(I3:I5,G3:G5)","v":0},{"$f":"SUMPRODUCT(J3:J5,F3:F5)","v":605.04162243669839}]
[]
[null,null,null,null,null,null,null,"Total Costs","Available Funds","Total Profit"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:I10)","v":494.69},500,{"$f":"Total_Revenue-Total_Costs","v":110.35162243669839}]
[]
[]
[null,null,null,null,null,null,null,"Objective","Min Total Lost Sales Cost","Max Profit"]
[null,null,null,null,null,null,null,"Total Order Quantity",71,29]

{"sheet":"Media","index":8,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,9]]}
["Media Ordering Model "]
["Product","Current Inventory","Expected Demand","Order Quantity","Updated Inventory","Actual Sales","Lost Sales","Order Cost","Lost Sales Cost","Sales Price"]
["Movies",5,22,33,{"$f":"Current_Inventory+Order_Quantity","v":38},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":22},{"$f":"Expected_Demand-Actual_Sales","v":0},7.31,2.9233212050722779,13.135279504855134]
["Shows",9,17,38,{"$f":"Current_Inventory+Order_Quantity","v":47},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":17},{"$f":"Expected_Demand-Actual_Sales","v":0},6.67,3.3633533400544113,12.765708637454392]
["Sports",13,10,0,{"$f":"Current_Inventory+Order_Quantity","v":13},{"$f":"MIN(_xlfn.SINGLE(Expected_Demand),_xlfn.SINGLE(Updated_Inventory))","v":10},{"$f":"Expected_Demand-Actual_Sales","v":0},5.84,2.5269157815241625,9.9048426493160715]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Order","Total Lost Sales","Total Revenue"]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(H3:H5,D3:D5)","v":494.69},{"$f":"SUMPRODUCT(I3:I5,G3:G5)","v":0},{"$f":"SUMPRODUCT(J3:J5,F3:F5)","v":605.04162243669839}]
[]
[null,null,null,null,null,null,null,"Total Costs","Available Funds","Total Profit"]
[null,null,null,null,null,null,null,{"$f":"SUM(H10:I10)","v":494.69},500,{"$f":"Total_Revenue-Total_Costs","v":110.35162243669839}]
[]
[]
[null,null,null,null,null,null,null,"Objective","Min Total Lost Sales Cost","Max Profit"]
[null,null,null,null,null,null,null,"Total Order Quantity",71,29]